﻿//************************************************//
//Author:Nguyen Tan Phat
//MSSV:1173025
//Class:11HT
#region
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using DTO;

namespace DAO
{
    public class ChiTietHoaDonDAO
    {
        public static SqlDataReader SelectByPhong(int maPhong, DateTime ngayTraPhong)
        {
            var pr = new SqlParameter[2];
            pr[0] = new SqlParameter(@"MaPhong", maPhong);
            pr[1] = new SqlParameter(@"NgayTraPhong", ngayTraPhong);
            return SqlHelper.ExecuteReader(ConnectionString.Text, CommandType.StoredProcedure, "CTHoaDonByPhong", pr);
        }
    }
}
#endregion
//************************************************//



